/opt/conda/lib/python3.9/site-packages/geopandas/_compat.py:111: UserWarning: The Shapely GEOS version (3.10.2-CAPI-1.16.0) is incompatible with the GEOS version PyGEOS was compiled with (3.10.1-CAPI-1.16.0). Conversions between both will be slow. warnings.warn(
'346 total applications'
'121 different organizations applied.'
How many applications were submitted through the consolidated application?
Yes 343 No 3 Name: consolidated_application, dtype: int64
How many applications were submitted vs. not submitted?
Submitted 338 Not Submitted 8 Name: application_status, dtype: int64
The following organizations did not submit their one of applications.
['City of Tracy', 'County of Siskiyou', 'Metropolitan Transportation Commission', 'Redding Area Bus Aurthority', 'San Francisco Municipal Transportation Agency', 'Tuolumne County Transit Agency', 'Western Contra Costa Transit Authority']
/tmp/ipykernel_7186/3732048006.py:2: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
| total_state_fed_only | |
|---|---|
| 346 | $624.0M |
/tmp/ipykernel_7186/415235289.py:1: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.

/tmp/ipykernel_7186/943889312.py:2: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
Methodology


| all_programs | values | percentage_of_total_applications | |
|---|---|---|---|
| 0 | LCTOP (State) | 99 | 30% |
| 1 | 5311 (Fed) | 72 | 21% |
| 2 | 5311 (Fed),Transit Development Act (State) | 39 | 12% |
| 3 | 5339 (Fed) | 29 | 9% |
| 4 | 5311(f) (Fed) | 15 | 4% |
| 5 | 5311 (Fed),Other State Funds | 14 | 4% |
| 6 | 5339 (Fed),Other State Funds | 11 | 3% |
| 7 | 5311(f) (Fed),Transit Development Act (State) | 9 | 3% |
| 8 | 5311 CMAQ (Fed) | 6 | 2% |
| 9 | 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) | 5 | 1% |
| program combinations | count of applications in this combination | |
|---|---|---|
| 0 | LCTOP (State),Other State Funds | 5 |
| 1 | 5311 (Fed),LCTOP (State) | 3 |
| 2 | 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Other State Funds | 2 |
| 3 | 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds | 2 |
| 4 | 5311 (Fed),LCTOP (State),Transit Development Act (State) | 2 |
| 5 | 5311 (Fed),LCTOP (State),Transit Development Act (State),Other State Funds,Other Federal Funds | 2 |
| 6 | LCTOP (State),SB1. State of Good Repair (State) | 2 |
| 7 | 5311 (Fed),LCTOP (State),Other Federal Funds | 1 |
| 8 | 5311 CMAQ (Fed),LCTOP (State),Other State Funds | 1 |
| 9 | LCTOP (State),Other Federal Funds | 1 |
| 10 | LCTOP (State),Other State Funds,Other Federal Funds | 1 |
| 11 | LCTOP (State),Transit Development Act (State),Other Federal Funds | 1 |
Methodology


Top 5 organizations by total funding they requested
| organization_name | full_district_name | total (millions) | |
|---|---|---|---|
| 0 | Peninsula Corridor Joint Powers Board | District 4: Bay Area / Oakland | $182.8M |
| 1 | Los Angeles County Metropolitan Transportation Authority | District 7: Los Angeles | $102.48M |
| 2 | Tulare County Regional Transportation Agency | District 6: Fresno / Bakersfield | $27.67M |
| 3 | Kern Regional Transit | District 6: Fresno / Bakersfield | $23.6M |
| 4 | San Francisco Municipal Transportation Agency | District 4: Bay Area / Oakland | $20.34M |
Number of organizations that applied for funds by district
| count_of_organizations | |
|---|---|
| full_district_name | |
| District 12: Orange County | 1 |
| District 11: San Diego | 3 |
| District 9: Bishop | 4 |
| District 7: Los Angeles | 6 |
| District 1: Eureka | 7 |
| District 2: Redding | 9 |
| District 5: San Luis Obispo / Santa Barbara | 10 |
| District 8: San Bernardino / Riverside | 12 |
| District 10: Stockton | 13 |
| District 3: Marysville / Sacramento | 15 |
| District 6: Fresno / Bakersfield | 18 |
| District 4: Bay Area / Oakland | 23 |
Interpretation Examples
| # of programs in a particular application | # of times the org submitted an application in this particular combination | ||
|---|---|---|---|
| organization_name | all_programs | ||
| Alameda-Contra Costa Transit District | LCTOP (State) | 1 | 2 |
| Amador Transit | 5311 (Fed),LCTOP (State) | 2 | 2 |
| 5339 (Fed) | 1 | 4 | |
| Butte County Association of Governments/ Butte Regional Transit | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| 5311(f) (Fed),Transit Development Act (State) | 2 | 1 | |
| Calaveras Transit Agency | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| LCTOP (State) | 1 | 1 | |
| City of Arcata | LCTOP (State) | 1 | 1 |
| City of Arvin | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| 5339 (Fed) | 1 | 3 | |
| City of Auburn | 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) | 3 | 1 |
| City of Banning | LCTOP (State) | 1 | 1 |
| City of Beaumont | LCTOP (State) | 1 | 1 |
| City of California City | 5311 (Fed) | 1 | 2 |
| City of Chowchilla | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| City of Clovis | LCTOP (State) | 1 | 1 |
| City of Corcoran - Corcoran Area Transit | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 1 | |
| City of Davis | LCTOP (State) | 1 | 1 |
| City of Dixon | 5311 (Fed) | 1 | 3 |
| 5311 (Fed),LCTOP (State) | 2 | 1 | |
| 5311 (Fed),Transit Development Act (State) | 2 | 1 | |
| City of Escalon | 5311 (Fed) | 1 | 1 |
| 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Transit Development Act (State),Other State Funds | 5 | 2 | |
| City of Fairfield | LCTOP (State),Other Federal Funds | 2 | 1 |
| City of Fresno | LCTOP (State) | 1 | 2 |
| City of Guadalupe | 5311 (Fed) | 1 | 2 |
| 5339 (Fed) | 1 | 4 | |
| LCTOP (State) | 1 | 1 | |
| City of Manteca | LCTOP (State) | 1 | 1 |
| City of McFarland | 5311 (Fed),Other State Funds | 2 | 2 |
| LCTOP (State) | 1 | 1 | |
| City of Needles | 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) | 3 | 2 |
| City of Ojai | 5311 (Fed),Other State Funds | 2 | 2 |
| 5311 CMAQ (Fed) | 1 | 1 | |
| City of Ridgecrest | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| City of Rio Vista | 5311 (Fed) | 1 | 1 |
| 5311 (Fed),Transit Development Act (State) | 2 | 2 | |
| City of Roseville | 5311 CMAQ (Fed),LCTOP (State),Other State Funds | 3 | 1 |
| LCTOP (State) | 1 | 1 | |
| City of San Luis Obispo Transit | LCTOP (State) | 1 | 1 |
| City of Santa Rosa | LCTOP (State) | 1 | 1 |
| City of Shafter | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| LCTOP (State),SB1. State of Good Repair (State) | 2 | 1 | |
| City of Solvang | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| LCTOP (State) | 1 | 1 | |
| City of Taft | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| LCTOP (State),Other State Funds | 2 | 1 | |
| City of Tehachapi | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| City of Tracy | LCTOP (State) | 1 | 1 |
| City of Union City | Other State Funds | 1 | 1 |
| City of Visalia | LCTOP (State) | 1 | 1 |
| City of Wasco | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| LCTOP (State) | 1 | 1 | |
| Colusa County Transit Agency | LCTOP (State) | 1 | 1 |
| County Connection | LCTOP (State) | 1 | 2 |
| County of Los Angeles - Department of Public Works | 5311 (Fed) | 1 | 2 |
| County of Mariposa | 5311 (Fed) | 1 | 2 |
| County of Nevada Public Works, Transit Services Division | 5311 (Fed),Transit Development Act (State) | 2 | 1 |
| LCTOP (State) | 1 | 1 | |
| County of Sacramento Department of Transportation | 5311 (Fed) | 1 | 2 |
| County of Shasta Department of Public Works | 5311 (Fed),Other State Funds | 2 | 2 |
| 5311(f) (Fed) | 1 | 1 | |
| County of Siskiyou | LCTOP (State) | 1 | 3 |
| County of Tulare | LCTOP (State) | 1 | 1 |
| Eastern Contra Costa Transit Authority | LCTOP (State) | 1 | 1 |
| Eastern Sierra Transit Authority | 5311 (Fed) | 1 | 4 |
| 5311(f) (Fed),Transit Development Act (State) | 2 | 1 | |
| 5311(f) (Fed),Transit Development Act (State),Other State Funds | 3 | 1 | |
| 5339 (Fed) | 1 | 4 | |
| LCTOP (State) | 1 | 2 | |
| LCTOP (State),SB1. State of Good Repair (State) | 2 | 1 | |
| El Dorado County Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311(f) (Fed) | 1 | 1 | |
| LCTOP (State) | 1 | 1 | |
| LCTOP (State),Other State Funds | 2 | 1 | |
| Fresno County Rural Transit Agency | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 1 | |
| Glenn County Transportation Commission | 5311 (Fed) | 1 | 1 |
| Golden Empire Transit District | LCTOP (State) | 1 | 1 |
| Golden Gate Highway & Transportation District | LCTOP (State),Other State Funds,Other Federal Funds | 3 | 1 |
| Greyhound Lines, Inc. | 5311(f) (Fed) | 1 | 1 |
| Humboldt Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311 (Fed),Transit Development Act (State) | 2 | 2 | |
| 5311(f) (Fed),Transit Development Act (State) | 2 | 2 | |
| 5339 (Fed) | 1 | 1 | |
| LCTOP (State) | 1 | 1 | |
| Imperial County Transportation Commission | 5311 (Fed),Transit Development Act (State),Other State Funds,Other Federal Funds | 4 | 2 |
| LCTOP (State) | 1 | 1 | |
| Kern Regional Transit | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| 5339 (Fed),Other State Funds | 2 | 3 | |
| LCTOP (State) | 1 | 1 | |
| Kings County Area Public Transit Agency | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 3 | |
| Lake Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311(f) (Fed) | 1 | 2 | |
| 5339 (Fed),Other State Funds | 2 | 4 | |
| LCTOP (State) | 1 | 1 | |
| Lassen Transit Service Agency | 5311 (Fed),Other State Funds | 2 | 2 |
| 5339 (Fed) | 1 | 3 | |
| Livermore Amador Valley Transit Authority | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 1 | |
| Los Angeles County Metropolitan Transportation Authority | LCTOP (State) | 1 | 2 |
| Madera County | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| Madera County Transportation Commission | LCTOP (State) | 1 | 3 |
| Marin County Transit District | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 1 | |
| Mendocino Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311(f) (Fed) | 1 | 1 | |
| Metropolitan Transportation Commission | LCTOP (State) | 1 | 2 |
| Modoc Transportation Agency | 5311 (Fed),Transit Development Act (State) | 2 | 1 |
| 5311(f) (Fed),Transit Development Act (State) | 2 | 3 | |
| Monterey-Salinas Transit | 5311 (Fed) | 1 | 2 |
| 5311(f) (Fed) | 1 | 1 | |
| LCTOP (State) | 1 | 4 | |
| Morongo Basin Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311 CMAQ (Fed) | 1 | 1 | |
| LCTOP (State) | 1 | 2 | |
| Mountain Area Regional Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311 CMAQ (Fed) | 1 | 4 | |
| 5311(f) (Fed) | 1 | 2 | |
| LCTOP (State) | 1 | 1 | |
| Napa Valley Transportation Authority | 5311 (Fed),Transit Development Act (State) | 2 | 1 |
| 5311(f) (Fed),Transit Development Act (State) | 2 | 2 | |
| Other State Funds | 1 | 1 | |
| North County Transit District | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 1 | |
| Omnitrans | LCTOP (State) | 1 | 2 |
| Orange County Transportation Authority | LCTOP (State) | 1 | 2 |
| Palo Verde Valley Transit Agency | 5311 (Fed),Transit Development Act (State) | 2 | 1 |
| Peninsula Corridor Joint Powers Board | LCTOP (State),Other State Funds | 2 | 1 |
| Plumas County Transportation Commission | 5311 (Fed),SB1. State of Good Repair (State),Transit Development Act (State) | 3 | 2 |
| 5311(f) (Fed),SB1. State of Good Repair (State),Other State Funds | 3 | 1 | |
| 5311(f) (Fed),SB1. State of Good Repair (State),Transit Development Act (State) | 3 | 1 | |
| 5339 (Fed) | 1 | 3 | |
| LCTOP (State) | 1 | 1 | |
| Redding Area Bus Aurthority | LCTOP (State) | 1 | 1 |
| Redwood Coast Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311(f) (Fed) | 1 | 1 | |
| 5339 (Fed) | 1 | 3 | |
| LCTOP (State) | 1 | 1 | |
| Riverside County Transportation Commission | LCTOP (State) | 1 | 1 |
| Riverside Transit Agency | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 1 | |
| Sacramento Regional Transit District | LCTOP (State) | 1 | 6 |
| San Benito County Local Transportation Authority | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| LCTOP (State) | 1 | 2 | |
| San Bernardino County Transportation Authority | LCTOP (State) | 1 | 2 |
| San Diego Metropolitan Transit System | 5311(f) (Fed) | 1 | 1 |
| LCTOP (State) | 1 | 1 | |
| San Francisco Bay Area Rapid Transit | LCTOP (State) | 1 | 1 |
| San Francisco Bay Area Water Emergency Transportation Authority | LCTOP (State) | 1 | 1 |
| San Francisco Municipal Transportation Agency | LCTOP (State) | 1 | 2 |
| San Joaquin Regional Rail Commission | LCTOP (State) | 1 | 1 |
| San Joaquin Regional Transit District | 5311 (Fed) | 1 | 2 |
| LCTOP (State) | 1 | 1 | |
| San Luis Obispo Regional Transit Authority | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| LCTOP (State),Transit Development Act (State),Other Federal Funds | 3 | 1 | |
| San Mateo County Transit District | 5311 (Fed) | 1 | 2 |
| Other State Funds,Other Federal Funds | 2 | 1 | |
| Santa Barbara County Association of Governments | LCTOP (State) | 1 | 1 |
| Santa Barbara Metropolitan Transit District | Other State Funds | 1 | 1 |
| Santa Clara Valley Transportation Authority | 5311 (Fed) | 1 | 2 |
| Other State Funds | 1 | 1 | |
| Santa Cruz County Regional Transportation Commission | LCTOP (State) | 1 | 1 |
| Santa Cruz Metropolitan Transit District | 5311 (Fed) | 1 | 2 |
| 5339 (Fed) | 1 | 1 | |
| LCTOP (State) | 1 | 1 | |
| Shasta Regional Transportation Agency | LCTOP (State) | 1 | 1 |
| Sierra County Transportation Commission | 5311 (Fed) | 1 | 2 |
| 5339 (Fed) | 1 | 2 | |
| Solano County Transit | LCTOP (State),Other State Funds | 2 | 1 |
| Sonoma County Transit | 5311 (Fed) | 1 | 2 |
| Sonoma-Marin Area Rail Transit District | LCTOP (State) | 1 | 1 |
| Southern California Regional Rail Authority | LCTOP (State) | 1 | 1 |
| Stanislaus Council of Governments | LCTOP (State) | 1 | 1 |
| Stanislaus Regional Transit Authority | 5311 (Fed),Transit Development Act (State) | 2 | 2 |
| Sunline Transit Agency | 5311 (Fed) | 1 | 2 |
| 5311(f) (Fed) | 1 | 1 | |
| LCTOP (State) | 1 | 1 | |
| Tehama County Transit Agency | 5311 (Fed),LCTOP (State),Transit Development Act (State) | 3 | 2 |
| LCTOP (State) | 1 | 1 | |
| Town of Truckee | 5311 (Fed),LCTOP (State),Transit Development Act (State),Other State Funds,Other Federal Funds | 5 | 2 |
| Trinity County Department of Transportation | 5311 (Fed) | 1 | 4 |
| 5311(f) (Fed) | 1 | 2 | |
| 5339 (Fed) | 1 | 1 | |
| Tulare County Regional Transportation Agency | 5311 (Fed),Transit Development Act (State),Other Federal Funds | 3 | 2 |
| 5339 (Fed),Other State Funds | 2 | 4 | |
| Tuolumne County Transit Agency | 5311 (Fed),LCTOP (State),SB1. State of Good Repair (State),Other State Funds | 4 | 2 |
| LCTOP (State) | 1 | 1 | |
| Ventura County Transportation Commission | 5311 (Fed),Other State Funds | 2 | 2 |
| LCTOP (State) | 1 | 2 | |
| Victor Valley Transit Authority | 5311 (Fed),LCTOP (State),Other Federal Funds | 3 | 1 |
| 5311 (Fed),Other Federal Funds | 2 | 1 | |
| Western Contra Costa Transit Authority | LCTOP (State) | 1 | 1 |
| Yolo County Transportation District | 5311 (Fed) | 1 | 2 |
| LCTOP (State),Other State Funds | 2 | 1 | |
| Yuba-Sutter Transit Authority | 5311 (Fed) | 1 | 2 |
| 5311 (Fed),Other State Funds | 2 | 4 | |
| LCTOP (State) | 1 | 1 | |
| Yurok Tribe Transit | 5311(f) (Fed) | 1 | 1 |